{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lists","ALL Crest"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":88,"n_cols":43,"rows_kept":88,"cut":false,"hidden":false,"merged":[[27,0,27,1],[27,3,27,4],[27,5,27,6]]}
[]
["MODEL","BOILER TYPE","MAKE","MODEL","AHRI EFFICIENCY","FUEL","INPUT\n(btuh)","MAX.\nOUTPUT\n(btuh)","MIN.\nOUTPUT\n(btuh)","TURNDOWN RATIO","MIN-MAX. INLET PRESSURE\n(IN. W.C.)","GALLON CAPACITY","Max. Pressure Rating","Relief Valve Pressure Rating","MINIMUM FLOW RATE (GPM)","MAXIMUM FLOW RATE (GPM)","DESIGN SYSTEM \nDELTA T\n(oF)","20°F ΔT WATER FLOW (GPM)","HEAD LOSS\n(FT. OF HD.)","E.W.T.\n(oF)","L.W.T.\n(oF)","VOLTAGE/\nPHASE","TOTAL AMPS (FLA)","VENT SIZE","VENT MATERIAL","OPERATING WEIGHT   (lbs.)","DIMENSIONS",null,"Relief Valve PSI","Fuel","DeltaT","MODEL","FLOW\n20","FT/HD\n20","MODEL","FLOW\n30","FT/HD\n30","MODEL","FLOW\n40","FT/HD\n40","MODEL","FLOW\n60","FT/HD\n60"]
["FB-0751","Condensing\nStainless Steel \nFiretube","LOCHINVAR","FB-0751",0.96199999999999997,null,750000,722000,48100,"15:1",null,73,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",5,6,"SS, CPVC, PVC, or Polypro",1768,"78 x 30\nx 57-5/8",null,50,"Natural Gas",20,"FB-0751",72,4.8,"FB-0751",48.18,3.8,"FB-0751",36,3,"FB-0751",24,2.5]
["FB-1001","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-1001",0.96199999999999997,null,999000,961000,48100,"20:1",null,77,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",6,6,"SS, CPVC, PVC, or Polypro",1838,"78 x 30\nx 57-5/8",null,75,"LP",30,"FB-1001",96,8.3000000000000007,"FB-1001",64.17,6.9,"FB-1001",48,6,"FB-1001",32,5.5]
["FB-1251","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-1251",0.96199999999999997,null,1250000,1203000,{"$f":"H5/20","v":60150},"20:1",null,87,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",7,8,"SS, CPVC, PVC, or Polypro",1975,"78 x 30\nx 57-3/4",null,100,"DUAL (Nat./LP)",40,"FB-1251",120,9.1999999999999993,"FB-1251",80.3,7,"FB-1251",60,6,"FB-1251",40,4.0999999999999996]
["FB-1501","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-1501",0.96199999999999997,null,1500000,1443000,{"$f":"H6/25","v":57720},"25:1",null,94,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",10,8,"SS, CPVC, PVC, or Polypro",2307,"78 x 30 x 68",null,125,null,60,"FB-1501",144,12.3,"FB-1501",96.35,8.9,"FB-1501",72,7.3,"FB-1501",78,5.8]
["FB-1751","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-1751",0.96199999999999997,null,1750000,1684000,{"$f":"H7/25","v":67360},"25:1",null,106,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",10,8,"SS, CPVC, PVC, or Polypro",2458,"78 x 30 x 68",null,150,null,null,"FB-1751",168,13.8,"FB-1751",112.41,10,"FB-1751",84,8.1,"FB-1751",56,6.7]
["FB-2001","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-2001",0.96199999999999997,null,1999000,1923000,{"$f":"H8/25","v":76920},"25:1",null,111,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",13,8,"SS, CPVC, PVC, or Polypro",2570,"78 x 30 x 68",null,null,null,null,"FB-2001",192,14.5,"FB-2001",128.41,10.1,"FB-2001",96,8.1,"FB-2001",64,6.6]
["FB-2501","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-2501",0.96,null,2500000,2400000,120000,"20:1",null,157,160,null,25,350,null,null,null,null,null,"208V/3PH/\n60Hz",4.5,9,"SS, CPVC, PVC, or Polypro",3600,"77-3/4 x 35 x 83-3/4",null,null,null,null,"FB-2501",240,8.4,"FB-2501",160.26,6.2,"FB-2501",120,5.3,"FB-2501",80,4.8]
["FB-3001","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-3001",0.96,null,3000000,2883000,{"$f":"H10/20","v":144150},"20:1",null,156,160,null,25,350,null,null,null,null,null,"208V/3PH/\n60Hz",6.5,10,"SS, CPVC, PVC, or Polypro",3900,"77-3/4 x 35 x 83-3/4",null,null,null,null,"FB-3001",288,8,"FB-3001",192.31,5.2,"FB-3001",144,4,"FB-3001",96,3.3]
["FB-3501","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-3501",0.96,null,3500000,3364000,{"$f":"H11/20","v":168200},"20:1",null,202,160,null,45,350,null,null,null,null,null,"208V/3PH/\n60Hz",6.5,10,"SS, CPVC, PVC, or Polypro",4600,"77-3/4 x 42 x 91-1/2",null,null,null,null,"FB-3501",336,9.9,"FB-3501",224.36,6.1,"FB-3501",168,5,"FB-3501",112,3.8]
["FB-4001","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-4001",0.96,null,3999000,3843000,{"$f":"H12/12","v":320250},"12:1",null,201,160,null,45,350,null,null,null,null,null,"480V/3PH/\n60Hz",6,12,"SS, CPVC, PVC, or Polypro",5200,"77-3/4 x 45-1/2 x 103-1/2",null,null,null,null,"FB-4001","350*\n(Based on 22oF pT)",10.9,"FB-4001",256.35000000000002,7.6,"FB-4001",192,5.9,"FB-4001",128,4.4000000000000004]
["FB-5001","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-5001",0.96,null,4999000,4804000,{"$f":"H13/10","v":480400},"10:1",null,254,160,null,50,600,null,null,null,null,null,"480V/3PH/\n60Hz",5,14,"Stainless Steel",5900,"77-3/4 x 46-1/2 x 102-1/4",null,null,null,null,"FB-5001",480,13.9,"FB-5001",320.45,10.7,"FB-5001",240,7.6,"FB-5001",160,5.5]
["FB-6001","Condensing\nStainless Steel\nFiretube","LOCHINVAR","FB-6001",0.96,null,6000000,5766000,{"$f":"H14/10","v":576600},"10:1",null,304,160,null,60,600,null,null,null,null,null,"480V/3PH/\n60Hz",7,14,"Stainless Steel",6900,"77-3/4 x 50 x 102-3/4\"",null,null,null,null,"FB-6001",576,17.2,"FB-6001",384.62,13,"FB-6001",288,9.4,"FB-6001",192,6.8]
["OF-0751","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-0751",0.96199999999999997,null,750000,722000,48100,"15:1",null,73,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",5,6,"SS, CPVC, PVC, or Polypro",1768,"87-1/8 x 30 x 67-3/8"]
["OF-1001","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-1001",0.96199999999999997,null,999000,961000,48100,"20:1",null,77,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",6,6,"SS, CPVC, PVC, or Polypro",1838,"87-1/8 x 30 x 67-3/8"]
["OF-1251","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-1251",0.96199999999999997,null,1250000,1203000,{"$f":"H17/20","v":60150},"20:1",null,87,160,null,18,350,null,null,null,null,null,"120V/1PH/\n60Hz",7,8,"SS, CPVC, PVC, or Polypro",1975,"87-1/8 x 30 x 67-3/8"]
["OF-1501","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-1501",0.96199999999999997,null,1500000,1443000,{"$f":"H18/25","v":57720},"25:1",null,94,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",10,8,"SS, CPVC, PVC, or Polypro",2307,"87-1/8 x 30 x 77-3/8"]
["OF-1751","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-1751",0.96199999999999997,null,1750000,1684000,{"$f":"H19/25","v":67360},"25:1",null,106,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",10,8,"SS, CPVC, PVC, or Polypro",2458,"87-1/8 x 30 x 77-3/8"]
["OF-2001","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-2001",0.96199999999999997,null,1999000,1923000,{"$f":"H20/25","v":76920},"25:1",null,111,160,null,25,350,null,null,null,null,null,"120V/1PH/\n60Hz",13,8,"SS, CPVC, PVC, or Polypro",2570,"87-1/8 x 30 x 77-3/8"]
["OF-2501","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-2501",0.96,null,2500000,2400000,120000,"20:1",null,157,160,null,25,350,null,null,null,null,null,"208V/3PH/\n60Hz",4.5,9,"SS, CPVC, PVC, or Polypro",3600,"87-3/16 x 37 x 92-3/4"]
["OF-3001","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-3001",0.96,null,3000000,2883000,{"$f":"H22/20","v":144150},"20:1",null,156,160,null,25,350,null,null,null,null,null,"208V/3PH/\n60Hz",6.5,10,"SS, CPVC, PVC, or Polypro",3900,"87-3/16 x 37 x 92-3/4"]
["OF-3501","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-3501",0.96,null,3500000,3364000,{"$f":"H23/20","v":168200},"20:1",null,202,160,null,45,350,null,null,null,null,null,"208V/3PH/\n60Hz",6.5,10,"SS, CPVC, PVC, or Polypro",4600,"87-1/4 x 42 x 95-7/16"]
["OF-4001","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-4001",0.96,null,3999000,3843000,{"$f":"H24/12","v":320250},"12:1",null,201,160,null,45,350,null,null,null,null,null,"480V/3PH/\n60Hz",6,12,"SS, CPVC, PVC, or Polypro",5200,"87-1/4 x 48 x 106-3/4"]
["OF-5001","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-5001",0.96,null,4999000,4804000,{"$f":"H25/10","v":480400},"10:1",null,254,160,null,50,600,null,null,null,null,null,"480V/3PH/\n60Hz",5,14,"Stainless Steel",5900,"87-1/4 x 48 x 95-7/16"]
["OF-6001","Condensing\nStainless Steel \nFiretube OUTDOOR","LOCHINVAR","OF-6001",0.96,null,6000000,5766000,{"$f":"H26/10","v":576600},"10:1",null,304,160,null,60,600,null,null,null,null,null,"480V/3PH/\n60Hz",7,14,"Stainless Steel",6900,"87-5/16 x 52-1/16 x 109-3/4"]
[]
["CONDENSATE KITS",null,null,"ECM Pumps",null,"Isolation Valves",null,null,null,null,"Natural Gas","LP","DUAL (Nat./LP)",null,null,"Natural Gas","LP","DUAL (Nat./LP)"]
["< Select >",null,null,"100208412 (20°F / FB 0751)",null,"100266962 (3” / FB 0751)",null,null,null,"FB-0751","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-0751","FBN0751","FBL0751","FBD0751"]
["100289340 (0751)",null,null,"100208412 (20°F / FB 1001)",null,"100266962 (3” / FB 1001)",null,null,null,"FB-1001","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-1001","FBN1001","FBL1001","FBD0751"]
["100289581 (1001-2001)",null,null,"100208412 (20°F / FB 1251)",null,"100266962 (3” / FB 1251)",null,null,null,"FB-1251","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-1251","FBN1251","FBL1251","FBD1251"]
["100289582 (2501-6001)",null,null,"100208412 (20°F / FB 1501)",null,"100157681 (4” / FB 1501)",null,null,null,"FB-1501","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-1501","FBN1501","FBL1501","FBD1501"]
["< Select >"," ",null,"100277760 (20°F / FB 1751)",null,"100157681 (4” / FB 1751)",null,null,null,"FB-1751","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-1751","FBN1751","FBL1751","FBD1751"]
["Primary-Secondary","Primary-Secondary piping: ECM boiler pump shall be provided with each boiler and controlled via a 0-10vdc (Field Wire) signal to maintain design Delta T.  ",null,"100277760 (20°F / FB 2001)",null,"100157681 (4” / FB 2001)",null,null,null,"FB-2001","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-2001","FBN2001","FBL2001","FBD2001"]
["Variable Primary","Variable Primary piping: Boiler isolation valves shall be provided on the outlet of each boiler and controlled by the boiler operating system.  ",null,"100189240 (20°F / FB 2501)",null,"100157681 (4” / FB 2501)",null,null,null,"FB-2501","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-2501","FBN2501","FBL2501","FBD2501"]
[null,null,null,"100189240 (20°F / FB 3001)",null,"100157681 (4” / FB 3001)",null,null,null,"FB-3001","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-3001","FBN3001","FBL3001","FBD3001"]
["< Select >"," ",null,"100189240 (20°F / FB 3501)",null,"100157681 (4” / FB 3501)",null,null,null,"FB-3501","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-3501","FBN3501","FBL3501","FBD3501"]
["4000 ft.","Up to 4,000 ft. elevation, the boiler shall have no de-rate. (6 MMBTU models allowed 8%)",null,null,null,null,null,null,null,"FB-4001","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-4001","FBN4001","FBL4001","FBD4001"]
["5000 ft.","Up to 5,000 ft. elevation, the boiler shall have no de-rate. (6 MMBTU models allowed 9%)",null,null,null,null,null,null,null,"FB-5001","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-5001","FBN5001","FBL5001","FBD5001"]
["5500 ft.","Up to 5,500 ft. elevation, the boiler shall have no de-rate. (6 MMBTU models allowed 11%)",null,"100189240 (20°F / FB 4001)",null,"100157681 (4” / FB4001)",null,null,null,"FB-6001","4 to 14","8 to 14","4 to 14 (Nat.)\n8 to 14 (LP)",null,"FB-6001","FBN6001","FBL6001","FBD6001"]
["6000 ft.","Up to 6,000 ft. elevation, the boiler shall have a de-rate of no greater than .8%. Consult factory for models 4 MMBTU and above.",null,"100208411 (40°F / FB 0751)",null,"100280019 (6” / FB 5001) ",null,null,null,"OF-0751","4 to 14","8 to 14","Not an option",null,"OF-0751","OFN0751","OFL0751","Not an option"]
["6500 ft.","Up to 6,500 ft. elevation, the boiler shall have a de-rate of no greater than 1.6%. Consult factory for models 4 MMBTU and above.",null,"100208411 (40°F / FB 1001)",null,"100280019 (6” / FB 6001) ",null,null,null,"OF-1001","4 to 14","8 to 14","Not an option",null,"OF-1001","OFN1001","OFL1001","Not an option"]
["7000 ft.","Up to 7,000 ft. elevation, the boiler shall have a de-rate of no greater than 2.4%. Consult factory for models 4 MMBTU and above.",null,"100208411 (40°F / FB 1251)",null,null,null,null,null,"OF-1251","4 to 14","8 to 14","Not an option",null,"OF-1251","OFN1251","OFL1251","Not an option"]
["7500 ft.","Up to 7,500 ft. elevation, the boiler shall have a de-rate of no greater than 3.2%. Consult factory for models 4 MMBTU and above.",null,"100208411 (40°F / FB 1501)",null,null,null,null,null,"OF-1501","4 to 14","8 to 14","Not an option",null,"OF-1501","OFN1501","OFL1501","Not an option"]
["8000 ft.","Up to 8,000 ft. elevation, the boiler shall have a de-rate of no greater than 4.0%. Consult factory for models 4 MMBTU and above.",null,"100208412 (40°F / FB 1751)",null,null,null,null,null,"OF-1751","4 to 14","8 to 14","Not an option",null,"OF-1751","OFN1751","OFL1751","Not an option"]
["8500 ft.","Up to 8,500 ft. elevation, the boiler shall have a de-rate of no greater than 4.8%. Consult factory for models 4 MMBTU and above.",null,"100208412 (40°F / FB 2001)",null,null,null,null,null,"OF-2001","4 to 14","8 to 14","Not an option",null,"OF-2001","OFN2001","OFL2001","Not an option"]
["9000 ft.","Up to 9,000 ft. elevation, the boiler shall have a de-rate of no greater than 5.6%. Consult factory for models 4 MMBTU and above.",null,"100208412 (40°F / FB 2501)",null,null,null,null,null,"OF-2501","4 to 14","8 to 14","Not an option",null,"OF-2501","OFN2501","OFL2501","Not an option"]
["9500 ft.","Up to 9,500 ft. elevation, the boiler shall have a de-rate of no greater than 6.4%. Consult factory for models 4 MMBTU and above.",null,"100208412 (40°F / FB 3001)",null,null,null,null,null,"OF-3001","4 to 14","8 to 14","Not an option",null,"OF-3001","OFN3001","OFL3001","Not an option"]
["10000 ft.","Up to 10,000 ft. elevation, the boiler shall have a de-rate of no greater than 7.2%. Consult factory for models 4 MMBTU and above.",null,"100208412 (40°F / FB 3501)",null,null,null,null,null,"OF-3501","4 to 14","8 to 14","Not an option",null,"OF-3501","OFN3501","OFL3501","Not an option"]
["10500 ft.","Up to 10,500 ft. elevation, the boiler shall have a de-rate of no greater than 8.0%. Consult factory for models 4 MMBTU and above.",null,"100277760 (40°F / FB 4001)",null,null,null,null,null,"OF-4001","4 to 14","8 to 14","Not an option",null,"OF-4001","OFN4001","OFL4001","Not an option"]
[null,null,null,"100277760 (40°F / FB 5001)",null,null,null,null,null,"OF-5001","4 to 14","8 to 14","Not an option",null,"OF-5001","OFN5001","OFL5001","Not an option"]
[null,null,null,"100189240 (40°F / FB 6001)",null,null,null,null,null,"OF-6001","4 to 14","8 to 14","Not an option",null,"OF-6001","OFN6001","OFL6001","Not an option"]
[null,null,null,"100208411 (60°F / FB 1251)"]
[null,null,null,"100208411 (60°F / FB 1501)"]
[null,null,null,"100208411 (60°F / FB 1751)"]
[null,null,null,"100208411 (60°F / FB 2001)"]
[null,null,null,"100208411 (60°F / FB 2501)"]
[null,null,null,"100208411 (60°F / FB 3001)"]
["< Select >",null,null,"100208412 (60°F / FB 3501)"]
["up to 2 psi",null,null,"100208412 (60°F / FB 4001)"]
["up to 5 psi",null,null,"100277760 (60°F / FB 5001)"]
[null,null,null,"100277760 (60°F / FB 6001)"]
[]
["< Select >",null,"up to 2 psi","up to 5 psi"]
[null,"FB-0751",100269922,100320058]
[null,"FB-1001",100269922,100320058]
[null,"FB-1251",100269923,100320059]
[null,"FB-1501",100269923,100320059]
[null,"FB-1751",100269923,100320059]
[null,"FB-2001",100269923,100320059]
[null,"FB-2501",100269924,100320060]
[null,"FB-3001",100269924,100320060]
[null,"FB-3501",100269924,100320060]
[null,"FB-4001",100269925,100320061]
[null,"FB-5001",100269925,100320061]
[null,"FB-6001",100320057,100320062]
[null,"OF-0751",100269922,100320058]
[null,"OF-1001",100269922,100320058]
[null,"OF-1251",100269923,100320059]
[null,"OF-1501",100269923,100320059]
[null,"OF-1751",100269923,100320059]
[null,"OF-2001",100269923,100320059]
[null,"OF-2501",100269924,100320060]
[null,"OF-3001",100269924,100320060]
[null,"OF-3501",100269924,100320060]
[null,"OF-4001",100269925,100320061]
[null,"OF-5001",100269925,100320061]
[null,"OF-6001",100320057,100320062]

{"sheet":"ALL Crest","index":1,"n_rows":38,"n_cols":27,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,6,0,10],[4,21,4,22],[0,11,0,24],[1,7,1,8],[2,7,2,8],[1,10,1,11],[2,10,2,11],[1,16,1,17],[4,23,4,26],[25,5,25,6],[4,0,4,4],[1,22,1,23],[2,22,2,23],[1,19,1,20],[2,19,2,20],[4,5,4,10],[4,11,4,20],[1,1,1,2],[2,1,2,2],[1,4,1,5],[2,4,2,5],[1,13,1,14],[2,13,2,14],[3,4,3,5],[2,16,2,17],[25,0,25,1],[32,1,32,2],[15,0,15,1],[28,0,28,2],[25,2,25,3],[36,0,36,3]]}
["Boiler Cascade Schedule:",null,null,null,null,null,"1. Select model from drop-down choices in \"Boiler X\" box(es).\n2. Choose the variables (w/red headings) to complete the line item.\nNOTE: Cell values can be manually changed as needed. A new copy of the \nschedule will be needed to restore auto-population.",null,null,null,null,"This schedule is designed to be used for up to 8 boilers that will be in a cascade. This means a number of specifications will be the same for each unit.\nUse the drop down menus in columns with red headings to select the desired spec.\nFor units that stand alone, or are in a different area of the building; use the RESET button to create separate schedules."]
[null,"Boiler 1",null,null,"Boiler 2",null,null,"Boiler 3",null,null,"Boiler 4",null,null,"Boiler 5",null,null,"Boiler 6",null,null,"Boiler 7",null,null,"Boiler 8"]
[]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27]
["UNIT DESCRIPTION",null,null,null,null,"BURNER",null,null,null,null,null,"WATER",null,null,null,null,null,null,null,null,null,"ELECTRICAL",null,"DIMENSIONS"]
["TAG","BOILER TYPE","MAKE","MODEL","AHRI EFFICIENCY","FUEL","INPUT\n(btuh)","MAX.\nOUTPUT\n(btuh)","MIN.\nOUTPUT\n(btuh)","TURNDOWN RATIO","MIN-MAX. INLET PRESSURE\n(IN. W.C.)","GALLON CAPACITY","MAX.\nPRESSURE\nRATING\n(PSI)","RELIEF VALVE\nPRESSURE\nRATING\n(PSI)","MINIMUM FLOW RATE (GPM)","MAXIMUM FLOW RATE (GPM)","DESIGN SYSTEM \nDELTA T\n(oF)","WATER FLOW (GPM)\nBased on ΔT","HEAD LOSS\n(FT. OF HD.)\nBased on ΔT","RETURN\nW.T.\n(oF)","SUPPLY\nW.T.\n(oF)","VOLTAGE/\nPHASE","TOTAL AMPS (FLA)","VENT SIZE\n(inches)","VENT MATERIAL","OPERATING WEIGHT   (lbs.)","UNIT DIMENSIONS\n(inches)\nH x W x D"]
[{"$f":"IF($C7=\"lochinvar\",\"B-1\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$O29:R52,MATCH(F7,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$J29:$M52,MATCH(F7,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,M4,FALSE),\"\")","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,P4,FALSE),\"\")","v":""},null,{"$f":"IF($Q7=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q7=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q7=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q7=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q7=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q7=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q7=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q7=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},{"$f":"IF(U7=\"\",\"\",U7-Q7)","v":""},null,{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,X4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,Y4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$Z,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($B$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C8=\"lochinvar\",\"B-2\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$O29:R52,MATCH(F8,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},{"$f":"IF($E8=\"\",\"\",F7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$J29:$M52,MATCH(F8,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},{"$f":"IF($M8=\"\",\"\",N7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},{"$f":"IF($P8=\"\",\"\",Q7)","v":""},{"$f":"IF($Q8=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q8=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q8=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q8=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q8=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q8=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q8=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q8=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"",{"$f":"IF($V8=\"\",\"\",U7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"IF($Z8=\"\",\"\",Y7)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($E$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C9=\"lochinvar\",\"B-3\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$O29:R52,MATCH(F9,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$J29:$M52,MATCH(F9,Lists!$J28:$M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q9=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q9=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q9=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q9=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q9=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q9=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q9=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q9=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},{"$f":"IF($Z9=\"\",\"\",Y8)","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($H$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C10=\"lochinvar\",\"B-4\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$O29:R52,MATCH(F10,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$J29:$M52,MATCH(F10,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q10=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q10=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q10=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q10=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q10=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q10=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q10=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q10=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($K$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C11=\"lochinvar\",\"B-5\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$O29:R52,MATCH(F11,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$J29:$M52,MATCH(F11,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q11=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q11=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q11=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q11=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q11=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q11=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q11=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q11=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($N$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C12=\"lochinvar\",\"B-6\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$O29:R52,MATCH(F12,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$J29:$M52,MATCH(F12,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q12=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q12=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q12=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q12=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q12=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q12=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q12=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q12=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($Q$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C13=\"lochinvar\",\"B-7\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$O29:R52,MATCH(F13,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$J29:$M52,MATCH(F13,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q13=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q13=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q13=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q13=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q13=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q13=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q13=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q13=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($T$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[{"$f":"IF($C14=\"lochinvar\",\"B-8\",\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,B4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,C4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$O29:R52,MATCH(F14,Lists!$O28:R28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,E4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,G4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,H4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,I4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,J4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$J29:$M52,MATCH(F14,Lists!$J28:M28,0),FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,L4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,M4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,O4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,P4,FALSE),\"\")","v":""},"",{"$f":"IF($Q14=20,VLOOKUP($B$3,Lists!$AF:$AG,2,FALSE),IF($Q14=30,VLOOKUP($B$3,Lists!$AI:$AJ,2,FALSE),IF($Q14=40,VLOOKUP($B$3,Lists!$AL:$AM,2,FALSE),IF($Q14=60,VLOOKUP($B$3,Lists!$AO:$AP,2,FALSE),\"\"))))","v":""},{"$f":"IF($Q14=20,VLOOKUP($B$3,Lists!$AF:$AH,3,FALSE),IF($Q14=30,VLOOKUP($B$3,Lists!$AI:$AK,3,FALSE),IF($Q14=40,VLOOKUP($B$3,Lists!$AL:$AN,3,FALSE),IF($Q14=60,VLOOKUP($B$3,Lists!$AO:$AQ,3,FALSE),\"\"))))","v":""},"","",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,V4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,W4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,X4,FALSE),\"\")","v":""},"",{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,Z4,FALSE),\"\")","v":""},{"$f":"_xlfn.IFNA(VLOOKUP($W$3,Lists!$A:$AA,AA4,FALSE),\"\")","v":""}]
[]
["Schedule Notes:"]
["1.   Boiler shall meet ANSI Standard Z21.13 and thermal and combustion efficiencies and shall be AHRI certified.    "]
["2.   Boiler to be CSD-1 / Factory Mutual / GAPS, and California Code Compliant. "]
["3.   Boilers must be low NOX approved for South Coast Air Quality Management District Rule 1146.2 (for boilers up to 2000 MBH) and Bay Area Air Quality Management District. "]
["4.   Boiler heat exchanger shall be condensing, stainless steel, fire tube design.  No exceptions.  "]
["5.   Boiler shall be of a single burner and single heat exchanger design.  Designs with multiple burners and pressure vessels in a single jacket will not be accepted. "]
["6.   Boiler shall be CSA certified, at site altitude at high and low turndown ratio.    "]
["7.   Scheduled water volume is minimum allowed to prevent any increase in short cycling.   "]
["8.   Boiler shall not have a published excess 02% of more than 5.7%.  Excess 02% shall be validated by 02 sensor and readout on digital display.  "]
["9.   Provide an ultra high turndown gas regulator on each incoming boiler gas line sized per National Fuel Gas Code."]
["Select Max. Gas Pressure   >>",null,"< Select >",null,"P/N =",{"$f":"_xlfn.IFNA(VLOOKUP(B3,Lists!B65:D88,MATCH(C26,Lists!B64:D64,0),FALSE),\"\")","v":""}]
["10.   Boiler must integral cascade sequencer with BACnet MSTP interface, lead/lag, efficiency optimization, and cascade redundancy.  "]
["11.   Boiler shall have 8” touchscreen interface with WiFi and ethernet connection for remote monitoring and control.  "]
["12.   Select Piping Configuration      >>",null,null,"< Select >"]
[{"$f":"VLOOKUP(D29,Lists!A33:B35,2,FALSE)","v":" "}]
["13.   Boiler shall be able to anticipate system load changes via a 0-10vdc signal from the variable frequency drive and boiler low voltage contacts. "]
["14.   Condensate neutralization kit shall be provided with each boiler. "]
["P/N =","< Select >"]
["15.   Pressure vessel and heat exchanger shall be protected by a factory warranty that covers lifetime thermal shock, 5 year on burner and 18 months on parts.     "]
["16.   Factory trained start-up and owners training required.  Full verification of specified turndown ratio shall be witnessed by owners rep.  "]
["17.   Boilers shall be CSA approved for high altitude operation (up to 10,500 ft.).      "]
["Select elevation for high altitude deration permitted:   >>",null,null,null,"< Select >"]
[{"$f":"VLOOKUP(E37,Lists!A37:B50,2,FALSE)","v":" "}]